﻿CREATE PROCEDURE [acms].[Template_GetAllByChildTemplateId]
	@ChildTemplateId int
AS
	SELECT a.*
	From Template_View a
		inner join [TemplateHierarchy_View] b on a.Id = b.ParentId
	Where b.ChildId = @ChildTemplateId
	order by a.Name
RETURN 0;